Page 56 - Data_Science_Part_A C12

3.10.8 Statistical Functions

Statistical Functions take numeric argument(s) and produce results accordingly. Following are the different types of
statistical functions:
Table 3.3: A

Function Description
AVERAGE( ) Produces the average (mean) of the given arguments.

E.g.,=AVERAGE(10,20,30) will display 20
=AVERAGE(A1,A2,A3) Displays the average of the cells A1, A2 and A3
=AVERAGE(A1:A10) Displays the average of the cells from the range A1 to A10

MAX( ) Produces the largest value from the given range of cells.
E.g., =MAX(10,20,15,25) will display 25

=MAX(A1:A5) Displays the largest value from cell A1 to A5.
=MAX(B2:C4) Displays the largest value of cells B2, B3, B4,C2, C3 and C4.

MIN( ) Produces the smallest value from the given set of values/range of cells. E.g., = MIN(10,20,15,25) will
display 10
=MIN(A1,A2,A3) Displays the smallest value of cells A1, A2 & A3.

=MIN(B2:C3) Displays the smallest value of cells B2, B3, C2 & C3.

COUNT( ) Produces the number of arguments enclosed in small brackets.
E.g., = COUNT(1,2,15,25,3,6) will display 6
=COUNT(A1:A20) Displays output: 20 (If all cells i.e., A1 to A20 contain values).

3.10.9 Logical Functions

Logical Functions in LibreOffice Calc check the data and return the result TRUE if the condition is true, and FALSE if not.
Consider the syntax of logical functions and examples of their applications in the process of working with the LibreOffice
Calc program.
Table 3.4: A

Function Description
OR Produces TRUE if any condition enclosed in the bracket is TRUE, otherwise it produces FALSE.
E.g., =OR(5>3, 4<5, 4>15) will display TRUE.
=OR(3>6; 2<1) will display FALSE.

AND Produces TRUE if all the conditions enclosed in the bracket are TRUE, otherwise displays FALSE.

E.g.,=AND (5>3, 4<5, 4>15) will display FALSE. (As one of the conditions is FALSE)
=AND(5>3, 4<5) will display TRUE.

IF If the condition in the statement is TRUE, it will display the TRUE part otherwise it will display the FALSE
part.
E.g., =IF(4>5,4,5) will display 5 since the condition is FALSE.

54 Touchpad Data Science-XII